Global Internet Business Solutions ~ GIBS

Tide Charts Module for DotNetNuke

Webmaster — Sat, 31 May 2025 10:55:00 GMT

Accurate, Interactive Tide Predictions for Your Website

Dynamic Weather Module for Your DNN Website

Webmaster — Sat, 24 May 2025 13:46:00 GMT

Enhance your website with our powerful and user-friendly Weather Module, designed to provide comprehensive and up-to-date weather information directly from OpenWeatherMap. Perfect for local businesses, community portals, or personal blogs, this module offers a rich, interactive weather experience for your visitors. Key Features & Benefits: Effortless Location Configuration: Easily set the target location by entering a City, State, and Country Code. Automated Latitude/Longitude Lookup: No need to manually find coordinates! Our integrated lookup feature automatically retrieves the precise latitude and longitude based on your entered location. Smart Location Selection: If multiple locations match your search (e.g., "Springfield"), a convenient dropdown allows you to select the exact one you need, ensuring accurate data. Rich Weather Data Display: Current Conditions at a Glance: Visitors get instant access to real-time temperature, "feels like" temperature, humidity, atmospheric pressure, cloud cover, UV index, and sunrise/sunset times. Detailed Wind Information: Displays wind speed in MPH, converts wind direction from degrees to clear compass points (e.g., "NW", "SE"), and includes wind gust data for a complete picture. Comprehensive Visibility: Shows visibility in both meters and automatically converted miles, catering to all user preferences. Precipitation Clarity: Provides precipitation probability and displays rainfall amounts in both millimeters (mm) and automatically converted inches (in). Interactive Forecasts: Hourly Temperature Chart: A visually engaging chart presents hourly temperature trends, allowing users to quickly see temperature fluctuations throughout the day. Daily Forecast Summary: Offers a multi-day outlook with high/low temperatures, day/night temperatures, "feels like" temperatures for different times of day, and a concise summary for each day. Timely Weather Alerts: Keeps your audience informed with real-time weather alerts, displaying the event type, sender, effective period, and detailed description, ensuring they are aware of any significant weather events. Seamless Integration & Management: DNN Module Integration: Designed as a native DotNetNuke module for easy installation and management within your DNN portal. Intuitive Settings Panel: A dedicated settings page allows administrators to configure the OpenWeatherMap API key and location details with ease. Localized Experience: Supports localized strings for all labels and messages, providing a tailored experience for your global audience. Give your website visitors the power of precise, up-to-date weather information with our feature-rich Weather Module! Sample The Module Here

Using DnnSoftware Platform to manage a food pantry

Webmaster — Thu, 27 Mar 2025 10:49:00 GMT

Using Dnn.Platform to manage a food pantry can offer several benefits, including: Increased Efficiency: Streamlined Operations: Dnn.Platform provides tools for online intake and registration, volunteer management, inventory control, and donation tracking. This can automate many manual tasks, freeing up valuable time for staff and volunteers to focus on serving clients. Improved communication: The platform facilitates communication with clients and volunteers through announcements, email blasts, and online forums. This can help keep everyone informed about pantry operations, volunteer opportunities, and upcoming events. Data-driven decision-making: Dnn.Platform provides data and analytics that can help food pantries track their progress, identify trends, and make informed decisions about resource allocation, program development, and outreach strategies. Enhanced Access and Services: Online application and registration: Clients can apply for assistance and register for services online, making it easier and more convenient for them to access the food pantry. 24/7 access to information: The platform can provide clients with access to pantry information, resources, and updates anytime, anywhere. Multilingual support: Dnn.Platform can be configured to support multiple languages, making it more accessible to a broader range of clients. Greater Transparency and Accountability: Donor management: Dnn.Platform provides tools for tracking donations, managing donor relationships, and issuing tax receipts. This can help build trust and transparency with donors. Financial reporting: The platform can generate reports on income, expenses, and inventory levels, which can be used for financial planning and reporting to stakeholders. Volunteer tracking: Dnn.Platform can track volunteer hours and activities, which can help demonstrate the value of volunteer contributions and recognize volunteers for their service. Additional Benefits: Reduced administrative costs: By automating many tasks and streamlining operations, Dnn.Platform can help food pantries reduce their administrative costs. Improved collaboration: The platform can facilitate collaboration between staff, volunteers, and donors, which can lead to more effective service delivery. Increased sustainability: By improving efficiency and transparency, Dnn.Platform can help food pantries become more sustainable organizations. Overall, Dnn.Platform can be a valuable tool for food pantries looking to improve efficiency, enhance access and services, and promote transparency and accountability. It can help food pantries better serve their communities and make a more significant impact on the lives of those in need

Create a Google QR Code for customer reviews

Webmaster — Thu, 09 Jan 2025 17:12:00 GMT

Steps on how to create a Google QR Code for customer reviews. Step 1: Go to the Google Place Finder Tool and look up your business in the search box. You can do that here. Step 2: Copy your businesses “Place ID” from the maps tooltip. Step 3: Modify the following Reviews URL and past in your “Place ID”: https://search.google.com/local/writereview?placeid=PUT ID HERE Step 4: Select a QR code generator you like. A free QR code generator you can use is here (QR Code Maker). Step 5: Copy and paste your new Reviews URL into your QR code website and download your QR code. Step 6: Print and use your QR code to start getting reviews! Hope this helps!

Estimated demand for QR Code use in 2025 and the future

Webmaster — Tue, 07 Jan 2025 16:37:00 GMT

It's estimated that by 2025, over 100 million smartphone users in the US will be scanning QR codes. This indicates a strong and growing demand for QR code use. This growth is driven by several factors: Increased smartphone adoption: As more people own smartphones, the potential user base for QR codes expands. Integration with mobile payments: QR codes are increasingly used for mobile payments, particularly in developing regions, driving their adoption. Juniper Research predicts that global spending using QR code payments will reach over $3 trillion by 2025. Versatility and convenience: QR codes offer a convenient way to access information, make payments, check in for events, and more. This versatility contributes to their widespread use across various industries. Omnichannel experiences: Businesses are increasingly using QR codes to connect online and offline experiences, creating seamless omnichannel journeys for customers. Overall, the demand for QR code use is expected to remain strong in 2025 and beyond, driven by technological advancements, increasing smartphone penetration, and the growing need for convenient and versatile solutions in various sectors. Sample our QR Code Maker DNN app.

Get DNN User CustomProperty Profile Data

Webmaster — Mon, 06 Jan 2025 15:51:00 GMT

private string GetUserProfileString(string CustomProperty, int UserID) { UserInfo oUserInfo = UserController.GetUserById(PortalSettings.PortalId, UserID); string sCustomProperty = oUserInfo.Profile.GetPropertyValue(CustomProperty); return sCustomProperty; }

What are the benefits of using the CMS DotNetNuke?

Webmaster — Mon, 28 Oct 2024 10:36:00 GMT

DNN (DotNetNuke) software, from dnnsoftware.com, offers several benefits as a Content Management System (CMS) Here are some of the key advantages: Content Management: Ease of Use: DNN boasts a user-friendly interface, allowing non-technical users to create, edit, and publish content without needing coding knowledge. Flexibility: The platform is highly customizable with modules, skins, and templates you can use to tailor the website to your specific needs. Scalability: DNN can handle large amounts of traffic and content, making it suitable for websites of all sizes, from small businesses to large enterprises. Security and Reliability: Security Features: DNN is built on the .NET framework, known for its strong security. It also offers additional features like user permissions, SSL support, and protection against common web attacks. Performance: DNN offers tools like web farms, module caching, and page caching to improve website loading speed and performance. Additional Advantages: Integration: DNN integrates with a wide range of third-party applications and systems, including payment gateways, social media, and marketing tools. Large Community: There's a large and active community of developers and users who provide support and resources to help you get the most out of the platform. Here are some things to consider as well: Learning Curve: While DNN offers a user-friendly interface, some advanced features might require some learning for non-technical users. Open Source vs. Paid: DNN offers a free, open-source version, but some features and support might be limited. Paid plans offer additional functionalities and support options. Overall, DNN can be a good choice for businesses and organizations looking for a secure, scalable, and customizable CMS with a user-friendly interface. For a more comprehensive view, you can also check out the official DNN website's resources on benefits: https://www.dnnsoftware.com/cms-features

New DNN 9.13 Install on Azure Bug

Tue, 30 Jul 2024 14:02:00 GMT

Fix here . .. install of DNN 9.9.1 on an Azure app service. The wizard completed successfully and then the site showed a 503 service unavailable error. Checking the logs gave me the message that "The file '/Admin/ControlPanel/ControlBar.ascx' does not exist." After a little while of frustrated searching, I discovered that the problem is that in the HostSettings table, the value for ControlPanel was set to '/Admin/ControlPanel/ControlBar.ascx' and needs to be set to 'DesktopModules/admin/Dnn.PersonaBar/UserControls/PersonaBarContainer.ascx' Making that change and then restarting the site fixed the problem for me.

Add Javascript to a DNN Page header in a Custom Module

Thu, 18 Apr 2024 09:55:00 GMT

How to Add Javascript to a DNN Page header section in a Custom Module protected override void OnInit(EventArgs e) { base.OnInit(e); DotNetNuke.Web.Client.ClientResourceManagement.ClientResourceManager.RegisterScript(this.Page, "https://translate.google.com/translate_a/element.js?cb=googleTranslateElementInit", FileOrder.Js.DefaultPriority, "DnnPageHeaderProvider"); }

How To Clear All Containers And Themes From Pages And Modules In DNN

Tue, 20 Feb 2024 20:06:00 GMT

Clear all page level skins in a Portal update {databaseOwner}{objectQualifier}Tabs set skinsrc=null where SkinSrc is not null and PortalID=0 Clear all page level containers in a Portal update {databaseOwner}{objectQualifier}tabs set containersrc=null where containersrc is not null and PortalID=0 Clear all module level containers in a Portal update {databaseOwner}{objectQualifier}TabModules set ContainerSrc = null where TabModuleID in (select TabModuleId from {databaseOwner}{objectQualifier}TabModules tm join {databaseOwner}{objectQualifier}Modules m on (tm.ModuleID = m.ModuleID) where ContainerSrc is not null and m.PortalId=0)

Optional Telerik Removal Steps

Fri, 26 Feb 2021 18:46:00 GMT

Noteworthy Changes in v9.8.0+ - Optional Telerik Removal The major highlight for this release is that we removed all our dependencies on the Telerik library. In oder to not make this a breaking change, we do leave Telerik removal as a manual option until v10. The main component that still relied on Telerik where Site Assets and Global assets which used Digital Assets Manager. We ship with v9.8.0 a new file manager that has no dependencies on Telerik but it is not installed by default to not break existing sites upon upgrades. Please note that it will be automatically replaced in v10, so please test and plan accordingly. To identify any third-party extension(s) that depend on Telerik, our very own @mitchelsellers has published the DNN Telerik Identifier module which you can download and install to to find assemblies that reference Telerik. Carefully review the results from this module to determine if your website is ready for full removal of Telerik. For any third-party modules that depend on Telerik, you should contact the module vendor/developer before following the steps below. If you would like to remove Telerik in DNN 9.8.0 following are the steps to do so. Again, proceed with caution based on your findings using the DNN Telerik Identifier module above, as performing these steps may also break third-party extensions that depend on Telerik. We recommend you contact the developer/vendor in these cases for further guidance. Create a full backup of the site and database. Install the new Resource Manager module via Extensions > Available Extensions (Modules). Navigate to Manage > Site Assets via the Persona Bar and remove the Digital Assets Management module from the page. Add an instance of the Resource Manager module to the Site Assets page. Navigate to Manage > Global Assets via the Persona Bar and repeat Steps 3 & 4 for that page. Navigate to Settings > SQL Console via the Persona Bar and run the following script: UPDATE {databaseOwner}{objectQualifier}Packages SET IsSystemPackage = 0 WHERE Name IN ('DigitalAssetsManagement', 'DotNetNuke.Telerik.Web', 'DotNetNuke.Web.Deprecated', 'DotNetNuke.Website.Deprecated') GO DELETE FROM {databaseOwner}{objectQualifier}PackageDependencies WHERE (PackageName = 'DotNetNuke.Web.Deprecated') GO UPDATE {databaseOwner}[{objectQualifier}Lists] SET Text = 'DotNetNuke.Web.UI.WebControls.Internal.PropertyEditorControls.DateEditControl, DotNetNuke.Web' WHERE ListName = 'DataType' AND Value = 'Date' GO UPDATE {databaseOwner}[{objectQualifier}Lists] SET Text = 'DotNetNuke.Web.UI.WebControls.Internal.PropertyEditorControls.DateTimeEditControl, DotNetNuke.Web' WHERE ListName = 'DataType' AND Value = 'DateTime' GO Navigate to Settings > Servers in the Persona Bar and click the Clear Cache button in the top-right corner. Navigate to Settings > Extensions (Modules) in the Persona Bar and uninstall the Digital Assets Management extension. Be sure to check the Delete Files checkbox. Navigate to Settings > Extensions (Libraries) in the Persona Bar and uninstall the DotNetNuke Telerik Web Components extension. Be sure to check the Delete Files checkbox. Navigate to Settings > Extensions (Libraries) in the Persona Bar and uninstall the DNN Deprecated Web Controls Library extension. Be sure to check the Delete Files checkbox. Navigate to Settings > Extensions (Libraries) in the Persona Bar and uninstall the DotNetNuke Deprecated Website Codebehind files extension. Be sure to check the Delete Files checkbox. Open the web.config file within the site root and search for "Telerik". Delete any lines that reference it. Test all third-party modules to make sure they still work without Telerik. If any do not work properly, please contact the developer/vendor for further guidance.

SQL Function to Lookup DNN Profile Values

Mon, 01 Feb 2021 20:20:00 GMT

CREATE FUNCTION GIBS_GetProfileElement ( @userID as int, @portalID as int, @ProfilePropertyName as nvarchar(100) ) RETURNS nvarchar(4000) AS BEGIN -- If input is invalid, return null. IF @ProfilePropertyName IS NULL OR LEN(@ProfilePropertyName) = 0 OR @userID IS NULL OR @userID < 1 RETURN NULL DECLARE @PropertyValue AS NVARCHAR(400) SET @PropertyValue = ( SELECT UserProfile.PropertyValue FROM (Users INNER JOIN UserProfile ON Users.UserID = UserProfile.UserID) INNER JOIN ProfilePropertyDefinition ON UserProfile.PropertyDefinitionID = ProfilePropertyDefinition.PropertyDefinitionID WHERE (((Users.UserID)=@userID) AND ((ProfilePropertyDefinition.PropertyName)=@ProfilePropertyName) AND ProfilePropertyDefinition.PortalID = @portalID) ) RETURN @PropertyValue END

Initializing a NotificationController in DNN 9

Wed, 21 Oct 2020 11:28:00 GMT

You can use NotificationsController.Instance.SendNotification method to send notifications. Here is an example: public void AddHtmlNotification(string subject, string body) { UserInfo _currentUser = DotNetNuke.Entities.Users.UserController.GetUserById(this.PortalId, PortalSettings.AdministratorId); var notificationType = NotificationsController.Instance.GetNotificationType("HtmlNotification"); // NEED THE PORTALID HERE AND AGENTID var sender = UserController.GetUserById(this.PortalId, this.UserId); var notification = new Notification { NotificationTypeID = notificationType.NotificationTypeId, Subject = subject, Body = body, IncludeDismissAction = true, SenderUserID = sender.UserID }; NotificationsController.Instance.SendNotification(notification, this.PortalId, null, new List { _currentUser }); }

Disable DNN Popup Windows

Wed, 23 Sep 2020 10:19:00 GMT

UPDATE PortalSettings SET SettingValue = 'False' WHERE SettingName = 'EnablePopUps'

Create DNN List Using ListController()

Mon, 27 Jan 2020 13:52:00 GMT

public void CreateList() { try { //create a placeholder entry - const string listName = "InventoryReportingType"; var listController = new ListController(); var entry = new ListEntryInfo(); { entry.DefinitionID = -1; entry.ParentID = 0; entry.Level = 0; entry.PortalID = this.PortalId; entry.ListName = listName; entry.Value = "USDA"; entry.Text = "USDA"; entry.SystemList = false; entry.SortOrder = 1; } listController.AddListEntry(entry); } catch (Exception ex) { Exceptions.ProcessModuleLoadException(this, ex); } }

Enabling the File Upload Function in DNN CKEditor

Fri, 10 Jan 2020 12:06:00 GMT

https://dnnsupport.dnnsoftware.com/hc/en-us/articles/360010074593-Enabling-the-File-Upload-Function-in-CKEditor

DisplayName Lookup by UserID

Thu, 26 Dec 2019 19:03:00 GMT

public string CreatedByUserName { get { if (createdByUserName == null) { int portalId = PortalController.Instance.GetCurrentPortalSettings().PortalId; UserController controller = new UserController(); UserInfo user = controller.GetUser(portalId, createdByUserID); if(user != null) { createdByUserName = user.DisplayName; } else { createdByUserName = "Deleted User"; } } return createdByUserName; } }

Check If Profile Property Exists

Tue, 24 Dec 2019 12:30:00 GMT

Check if a DNN TrueFalse (bool) profile property exists and if it doesn't create a new one USE: CheckProfilePropertyExistsTrueFalse("DoNotMail").ToString(); public string CheckProfilePropertyExistsTrueFalse(string propertyName) { string value = null; ProfilePropertyDefinition ppd = ProfileController.GetPropertyDefinitionByName(this.PortalId, propertyName.ToString()); // ProfileController.AddPropertyDefinition() if (ppd == null) { // IT DOESN'T EXIST - - CREATE IT DotNetNuke.Common.Lists.ListController objListCtrl = new DotNetNuke.Common.Lists.ListController(); DotNetNuke.Entities.Profile.ProfilePropertyDefinition objDef = new DotNetNuke.Entities.Profile.ProfilePropertyDefinition(); DotNetNuke.Entities.Profile.ProfileController objProfileController = new DotNetNuke.Entities.Profile.ProfileController(); objDef.DataType = objListCtrl.GetListEntryInfo("DataType", "TrueFalse").EntryID; objDef.Length = 50; objDef.PortalId = this.PortalId; objDef.PropertyName = propertyName.ToString(); // This is your property Name objDef.Required = false; objDef.DefaultValue = "false"; objDef.ViewOrder = -1; objDef.DefaultVisibility = DotNetNuke.Entities.Users.UserVisibilityMode.AdminOnly; objDef.Visible = true; objDef.PropertyCategory = "Donor"; objDef.ReadOnly = false; DotNetNuke.Entities.Profile.ProfileController.AddPropertyDefinition(objDef); value = "Profile Property Created for " + propertyName.ToString() + "!"; } else { value = "Profile Property Exists!"; } return value; }

2019 DNN UpdateServiceUrl

Mon, 11 Nov 2019 11:52:00 GMT

Thanks Mitch Sellers!

After upgrade "Error Loading SMTP Server Tab!" and mail has ceased working

Thu, 30 Nov 2017 14:13:00 GMT

Issue after upgrade from 8 to 9.1. I ended up deleting all settings in HostSettings and PortalSettings tables that started with SMTP*. Once I did that cleared cache and restarted dnn the page loaded fine and I was able to set the settings through the portal.

Add Stylesheet from Code Behind

Sun, 15 Oct 2017 13:04:00 GMT

Add a stylesheet from custom DNN module settings HtmlGenericControl css1 = new HtmlGenericControl("link"); css1.Attributes["type"] = "text/css"; if (Settings.Contains("jQueryUI")) { css1.Attributes["href"] = Settings["jQueryUI"].ToString(); } else { css1.Attributes["href"] = "https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/redmond/jquery-ui.css"; } css1.Attributes["rel"] = "stylesheet"; css1.Attributes["media"] = "screen"; Page.Header.Controls.Add(css1);

CheatSheet

Thu, 18 May 2017 18:12:00 GMT

A map of where things were in DNN 8 and where they can be found now in DNN 9. DNN 8 DNN 9 Administrators Super Users Admin / Event Viewer Manage / Admin Logs X X Admin / File Management Manage / Site Assets X X Admin / Page Management Content / Pages X X Admin / Recycle Bin Content / Recycle Bin X X Admin / Security Roles Manage / Roles X X Admin / Site Settings / Basic Settings / Site Details Settings / Site Settings / Site Info X X Admin / Site Settings / Basic Settings / Site Marketing Settings / SEO / Sitemap Settings / Site Submission X X Admin / Site Settings / Basic Settings / Appearance (logo / favicon) Settings / Site Settings / Site Info / Logo and Icons X X Admin / Site Settings / Basic Settings / Appearance (site/edit theme) Manage / Themes / Layouts X X Admin / Site Settings / Basic Settings / Appearance (site/edit container) Manage / Themes / Containers X X Admin / Site Settings / Advanced Settings / Page Management Settings / Site Settings / Site Behavior / Default Pages X X Admin / Site Settings / Advanced Settings / Security Settings Settings / Security / Login Settings / Basic Login Settings X X Admin / Site Settings / Advanced Settings / Payment Settings REMOVED Admin / Site Settings / Advanced Settings / Usability Settings (timezone) Settings / Site Settings / Site Info X X Admin / Site Settings / Advanced Settings / Usability Settings (other settings) REMOVED Admin / Site Settings / Advanced Settings / Site Aliases Settings / Site Settings / Site Behavior / Site Aliases X Admin / Site Settings / Advanced Settings / SMTP Server Settings Settings / Servers / Server Settings / SMTP Server X X Admin / Site Settings / Advanced Settings / SSL Settings Settings / Security / More X X Admin / Site Settings / Advanced Settings / Messaging Settings Settings / Site Settings / Site Behavior / Messaging X X Admin / Site Settings / Advanced Settings / Host Settings REMOVED Admin / Site Settings / Advanced Settings / Client Resource Management Settings / Servers / Server Settings / Performance / Client Resource Management X Admin / Site Settings / Advanced Settings / Page Output Settings Settings / Site Settings / Site Behavior / Default Pages / Page Output Settings X Admin / Site Settings / User Account Settings / Registration Settings Settings / Security / Member Accounts / Registration Settings X X Admin / Site Settings / User Account Settings / Login Settings Settings / Security / Login Settings / Basic Login Settings X X Admin / Site Settings / User Account Settings / Profile Settings Settings / Site Settings / Site Behavior / User Profiles X X Admin / Site Settings / Stylesheet Editor Settings / Custom CSS X X Admin / Site Settings / Advanced URL Settings REMOVED Admin / User Accounts Manage / Users X X Admin / Advanced Settings / Device Preview Management REMOVED Admin / Advanced Settings / Extensions Settings / Extensions X X Admin / Advanced Settings / Google Analytics REMOVED Admin / Advanced Settings / Languages Settings / Site Settings / Language X X Admin / Advanced Settings / Lists REMOVED Admin / Advanced Settings / Search Admin / General Settings / Site Settings / Search / Basic Settings / Search Index X X Admin / Advanced Settings / Search Admin / Synonyms Settings / Site Settings / Search / Synonyms X X Admin / Advanced Settings / Search Admin / Ignore Words Settings / Site Settings / Search / Ignore Words X X Admin / Advanced Settings / Search Engine Site Map Settings / SEO / Sitemap Settings X X Admin / Advanced Settings / Site Redirection Management REMOVED Admin / Advanced Settings / Site Wizard REMOVED Admin / Advanced Settings / Taxonomy Settings / Vocabularies X X Admin / Advanced Settings / Themes Manage / Themes X X Host / Dashboard / Web Server Settings / Servers / System Info / Web X Host / Dashboard / Database Server Settings / Servers / System Info / Database X Host / Dashboard / Host Settings / Servers / System Info / Application X X Host / Dashboard / Websites REMOVED Host / Dashboard / Modules REMOVED Host / Dashboard / Themes REMOVED Host / Extensions Settings / Extensions X Host / File Management Manage / Global Assets X Host / Host Settings / Basic Settings / Configuration / [Check for Upgrades] Settings / Site Settings / Site Behavior / More / [Check for Software Upgrades] X Host / Host Settings / Basic Settings / Configuration / [other settings] Settings / Servers / System Info X Host / Host Settings / Basic Settings / Host Details / [Enable Remember Me on Login Control] Settings / Security / More Security Settings / [Enable Remember Me on Login Control] X Host / Host Settings / Basic Settings / Host Details / [other settings] REMOVED Host / Host Settings / Basic Settings / Appearance REMOVED Host / Host Settings / Basic Settings / Payment Settings REMOVED Host / Host Settings / Advanced Settings / Friendly URL Settings REMOVED Host / Host Settings / Advanced Settings / Proxy Settings REMOVED Host / Host Settings / Advanced Settings / SMTP Server Settings Settings / Servers / Server Settings / SMTP Server X X Host / Host Settings / Advanced Settings / Performance Settings Settings / Servers / Server Settings / Performance X Host / Host Settings / Advanced Settings / jQuery Settings REMOVED Host / Host Settings / Advanced Settings / CDN Settings REMOVED Host / Host Settings / Advanced Settings / Client Resource Management Settings / Servers / Server Settings / Performance / Client Resource Management X Host / Host Settings / Advanced Settings / Membership Management Settings / Security / Member Accounts / Member Management X Host / Host Settings / Advanced Settings / Login IP Filters Settings / Security / Login Settings / Login IP Filters X Host / Host Settings / Advanced Settings / Search Settings Settings / Site Settings / Search / Basic Settings X Host / Host Settings / Other Settings Settings / Security / More / More Security Settings X Host / Host Settings / Logs Settings / Servers / Server Settings / Logs X Host / Site Management Manage / Sites X Host / Advanced Settings / Configuration Manager Settings / Configuration Manager X Host / Advanced Settings / Device Detection Management REMOVED Host / Advanced Settings / HTML Editor Manager Settings / Site Settings / Site Behavior / More / [Open HTML Editor Manager] X Host / Advanced Settings / Lists REMOVED Host / Advanced Settings / Schedule Settings / Scheduler X Host / Advanced Settings / Security Analyzer / Audit Checks Settings / Securty / Security Analyzer / Audit Checks X Host / Advanced Settings / Security Analyzer / Search Filesystem and Database Settings / Securty / Security Analyzer / Scanner Check X Host / Advanced Settings / Security Analyzer / Super User Activity Settings / Securty / Security Analyzer / SuperUser Activity X Host / Advanced Settings / Security Analyzer / Recently Modified Files Settings / Securty / Security Analyzer / Scanner Check / [Recently Modified Files] X Host / Advanced Settings / Security Analyzer / Recently Modified Settings Settings / Securty / Security Analyzer / Scanner Check / [Recently Modified Settings] X Host / Advanced Settings / SQL Settings / Sql Console X Host / Advanced Settings / SuperUser Accounts Manage / Users / [Show: Superusers] X Tools / Clear Cache Settings / Servers / [Clear Cache] X Tools / Restart Application Settings / Servers / [Restart Application] X

WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for 'jquery'.

Fri, 10 Mar 2017 19:34:00 GMT

System.InvalidOperationException: WebForms UnobtrusiveValidationMode requires a ScriptResourceMapping for 'jquery'. Please add a ScriptResourceMapping named jquery(case-sensitive). Solution Add below appSettings to the root web.configl file to solve this error.

GridView Trim Long String

Wed, 11 May 2016 13:32:00 GMT

Try this . . . .

Get State Code By State Name

Wed, 04 May 2016 11:17:00 GMT

DNN now returns the long state name when using DotNetNuke.Entities.Users.UserInfo . . . Here's an easy workaround for returning the 2 letter state code. public string GetStateByName(string name) { switch (name.ToUpper()) { case "ALABAMA": return "AL"; case "ALASKA": return "AK"; case "AMERICAN SAMOA": return "AS"; case "ARIZONA": return "AZ"; case "ARKANSAS": return "AR"; case "CALIFORNIA": return "CA"; case "COLORADO": return "CO"; case "CONNECTICUT": return "CT"; case "DELAWARE": return "DE"; case "DISTRICT OF COLUMBIA": return "DC"; case "FEDERATED STATES OF MICRONESIA": return "FM"; case "FLORIDA": return "FL"; case "GEORGIA": return "GA"; case "GUAM": return "GU"; case "HAWAII": return "HI"; case "IDAHO": return "ID"; case "ILLINOIS": return "IL"; case "INDIANA": return "IN"; case "IOWA": return "IA"; case "KANSAS": return "KS"; case "KENTUCKY": return "KY"; case "LOUISIANA": return "LA"; case "MAINE": return "ME"; case "MARSHALL ISLANDS": return "MH"; case "MARYLAND": return "MD"; case "MASSACHUSETTS": return "MA"; case "MICHIGAN": return "MI"; case "MINNESOTA": return "MN"; case "MISSISSIPPI": return "MS"; case "MISSOURI": return "MO"; case "MONTANA": return "MT"; case "NEBRASKA": return "NE"; case "NEVADA": return "NV"; case "NEW HAMPSHIRE": return "NH"; case "NEW JERSEY": return "NJ"; case "NEW MEXICO": return "NM"; case "NEW YORK": return "NY"; case "NORTH CAROLINA": return "NC"; case "NORTH DAKOTA": return "ND"; case "NORTHERN MARIANA ISLANDS": return "MP"; case "OHIO": return "OH"; case "OKLAHOMA": return "OK"; case "OREGON": return "OR"; case "PALAU": return "PW"; case "PENNSYLVANIA": return "PA"; case "PUERTO RICO": return "PR"; case "RHODE ISLAND": return "RI"; case "SOUTH CAROLINA": return "SC"; case "SOUTH DAKOTA": return "SD"; case "TENNESSEE": return "TN"; case "TEXAS": return "TX"; case "UTAH": return "UT"; case "VERMONT": return "VT"; case "VIRGIN ISLANDS": return "VI"; case "VIRGINIA": return "VA"; case "WASHINGTON": return "WA"; case "WEST VIRGINIA": return "WV"; case "WISCONSIN": return "WI"; case "WYOMING": return "WY"; } throw new Exception("Unavailable"); }

Order By Domain Name from Email Address

Sat, 23 Apr 2016 09:09:00 GMT

SELECT UserID, Username, FirstName, LastName, IsSuperUser, AffiliateId, Email, DisplayName, UpdatePassword, LastIPAddress, IsDeleted, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate, PasswordResetToken, PasswordResetExpiration, LowerEmail FROM Users ORDER BY RIGHT(Email, LEN(Email) - CHARINDEX('@', Email))

DNN 8 Upgrade Error

Sun, 20 Mar 2016 15:00:00 GMT

Module Load Warning One or more of the modules on this page did not load. This may be temporary. Please refresh the page (click F5 in most browsers). If the problem persists, please let the Site Administrator know. DNN 8 has eliminated the SolPartActions type which is typically referenced in your Containers. Go to your Containers folder: /Portals/x/Containers and open each .ascx file. Look for and REMOVE two things: <%@ Register TagPrefix="dnn" TagName="ACTIONS" Src="~/Admin/Containers/SolPartActions.ascx" %> and Or replace 1st line with . . . . <%@ Register TagPrefix="dnn" TagName="ACTIONS" Src="~/Admin/Menus/ModuleActions/ModuleActions.ascx" %>

DNN 8 Upgrade Skin Errors Fix

Fri, 19 Feb 2016 18:01:00 GMT

Declare @PortalID int; Set @PortalID = 1 update portalsettings set SettingValue = '[G]skins/Xcillion/inner.ascx' where SettingName = 'DefaultPortalSkin' and PortalId= @PortalID; update portalsettings set SettingValue = '[G]skins/Xcillion/inner.ascx' where SettingName = 'DefaultAdminSkin' and PortalId= @PortalID; update portalsettings set SettingValue = '[G]Containers/Xcillion/Title_h2.ascx' where SettingName = 'DefaultAdminContainer' and PortalId= @PortalID; update portalsettings set SettingValue = '[G]Containers/Xcillion/Title_h2.ascx' where SettingName = 'DefaultPortalContainer' and PortalId= @PortalID;

DNN Region Lookup

Tue, 16 Feb 2016 11:20:00 GMT

(SELECT [Value] FROM Lists where EntryID = (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Region' AND PortalID = @PortalID))) AS [State]

Ventrian Gallery Latest Template

Sat, 23 Jan 2016 11:09:00 GMT

Link to photo slideshow:

[PHOTOWITHBORDER]

Ventrian Gallery Latest Template

[PHOTOWITHBORDER] Ventrian Gallery Latest Template

SQL DNN Get User Profile with Region Lookup

Mon, 04 Jan 2016 11:13:00 GMT

Declare @PortalId int; Set @PortalId = 0; SELECT 'OwnerFirstName' = U.FirstName, 'OwnerLastName' = U.LastName, 'OwnerEmail' = U.Email , (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Telephone' AND PortalID = @PortalID)) AS OwnerTelephone , (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Cell' AND PortalID = @PortalID)) AS OwnerCell , (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Street' AND PortalID = @PortalID)) AS OwnerAddress , (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'City' AND PortalID = @PortalID)) AS OwnerCity , CASE WHEN ISNUMERIC((SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Region' AND PortalID = @PortalID))) = 1 THEN (SELECT [Value] FROM Lists where EntryID = (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Region' AND PortalID = @PortalID)) ) ELSE (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Region' AND PortalID = @PortalID)) END AS OwnerState -- (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'Region' AND PortalID = @PortalID)) AS OwnerState , (SELECT PropertyValue FROM UserProfile WHERE UserId = U.UserId AND PropertyDefinitionID = (SELECT PropertyDefinitionID FROM ProfilePropertyDefinition WHERE PropertyName = 'PostalCode' AND PortalID = @PortalID)) AS OwnerZip FROM Users U WHERE U.UserID = @UserID

10 Reasons to use DNN for new websites

Mon, 05 Jan 2015 17:02:00 GMT

As a web design consultant specializing in DNNSoftware, I often get asked the question "why use DNN?". Why not use Microsoft's SharePoint, or Content Management Server or some other system? Why not build from a new website from scratch? Decision makers in an organization may not be aware of the pros and cons of the various choices - and they will need good information to make a choice. Surprisingly, there is very few resources on the web with a list of reasons why to use DNN, so I have referenced the list below. 1. Have an instant website Simply download and run the installer, and get an instant website with a huge list of features. This website can be used immediately, will look professional and can be put online straight away. This website will allow you to easily add your own content using the large variety of built in modules. There will be no need to know HTML or other coding languages. To do all this when building a website from scratch would take several months effort - why make this effort when DNN does so much for you? 2. Plug in module based architecture Each separate piece of content on a DNN website is a module. This module based approach allows us to easily layout pages by selecting modules and placing them in the desired place on the page. Changed your mind about a modules location? Simply drag and drop it to where a new location. Try doing that with a website where the positions of items on the page are hard coded - it will require a rewrite just to move the items around. Need some functionality that is not provided by the built in modules? It is easy to write your own module in ASP.NET and plug it in with DNN's module manager. Or buy a module from a third party module developer, there are many useful modules available at very low prices. 3. Plug in skin based layouts DNN skins are a clip on cover for your website, just like the one for your cellphone or mp3 player. The obvious benefit of this is a consistent look and feel across an entire website. Skins are easy to operate, just choose the required skin from a list of skins and the whole website is updated to the new look. Try a different skin on a special occasion, like a christmas themed skin or a anniversary themed skin. Skins are easy to create too, and anyone who can create a html layout can create a skin. Skins even allow those who are not so skilled at design to create a good looking website. 4. Built in security and user management DNN contains secure and well implemented built in role based security. Use the built in security administration pages to have full control over who can view and edit your web pages. Have a public area and one or more secured areas. This is very useful for creating websites that charge a subscription for premium content. use the role based security to give editing rights to selected users. Security settings apply to all of the website's visitors including search engines - your restricted pages will not be indexed and will not be found on Google. How many websites have had sensitive documents found on a search engine - far too many! By having built in security from day one, this disaster can be avoided. 5. Built in event and error logging Want to know if everything is running smoothly on your website? Simply check the built in Event Log page to see what has happened. All errors are caught and logged automatically. Find out immediately what is going on, when it went wrong and where it went wrong. This very useful for anyone developing their own DNN modules. Websites without built in error logging will not know even know if anything is going wrong - ignorance is bliss? Probably not. 6. Resources available DNN has a very large developer community behind it. There are a wide variety of resources available, from free DNN skins, free DNN modules, low priced third party modules and skins. Use these resources to add value to your website. 7. Use for any type of web application DNN was originally created as a Content Management System, but it was soon realised that it could actually be used as the base for any type of web application. A huge variety of different websites have been created with DNN. 8. Performance and scalability DNN is designed for high performance, and includes built in support for web farms. DNN has been proven on several high visibility websites, like the Australian National Rugby League website www.nrl.com.au or even the DNN website www.DNN.com - with 3.7 million hits per month! 9. Large DNN community With over four hundred thousand registered users, DNN is one of the most popular website development frameworks available. This means there is continuous advancement and improvement in DNN, modules, skins, support and services. 10. BSD license DNN's BSD (Berkeley Software Distribution) license allows anyone to make a commercial product or service using DNN. There are no royalties. No strings, no tricks. Just download and go!

SQL Timeout on Custom DNN module

Wed, 08 Oct 2014 19:33:00 GMT

Try running . . . . exec sp_updatestats;

jQuery Modal in DNN

Tue, 30 Sep 2014 13:38:00 GMT

Get DNN User Profile Property Value

Sat, 27 Sep 2014 11:10:00 GMT

using DotNetNuke.Entities.Profile; string _value = GetUserProfilePropertyValue("MyCustomProfileField").ToString(); public string GetUserProfilePropertyValue(string propertyName) { string value = null; ProfilePropertyDefinition ppd = UserInfo.Profile.GetProperty(propertyName); if (ppd == null) { value = ""; } else { value = ppd.PropertyValue; if (value == null) { if (string.IsNullOrEmpty(ppd.DefaultValue)) { value = string.Empty; } else { value = ppd.DefaultValue; } } } return value; }

Set Custom Page Name in DNN

Tue, 23 Sep 2014 09:34:00 GMT

public void SetPageName(string PageName) { try { DotNetNuke.Framework.CDefault CustomPageName = (DotNetNuke.Framework.CDefault)this.Page; CustomPageName.Title = PageName.ToString(); } catch (Exception ex) { Exceptions.ProcessModuleLoadException(this, ex); } }

DNN 404 Errors on IIS 7 using ApplicationPoolIdentity

Tue, 02 Sep 2014 12:17:00 GMT

Solved on IIS7.Issue is in the web config the

DNN GetUsersByRoleName for a Dropdown

Sun, 06 Jul 2014 11:56:00 GMT

public void GetPreviousAgents(string _AgentRole) { try { DotNetNuke.Security.Roles.RoleController objRoleController = new DotNetNuke.Security.Roles.RoleController(); ArrayList objUserList = objRoleController.GetUsersByRoleName(DotNetNuke.Entities.Portals.PortalSettings.Current.PortalId, _AgentRole.ToString()); int i = 0; foreach (DotNetNuke.Entities.Users.UserInfo objUserInfo in objUserList) { ddlPreviousAgent.Items.Insert(i, new ListItem(objUserInfo.DisplayName.ToString(),objUserInfo.Email.ToString())); } } catch (Exception ex) { Exceptions.ProcessModuleLoadException(this, ex); } }

Fixed Cover Background Image

Fri, 27 Jun 2014 10:14:00 GMT

#Body { background-image: url(/Portals/2/bg1.jpg);background-size: cover !important; background-attachment: fixed;}

DNN Registration of jQuery and Plugins in DotNetNuke

Tue, 24 Jun 2014 12:53:00 GMT

protected override void OnInit(EventArgs e) { base.OnInit(e); JavaScript.RequestRegistration(CommonJs.jQuery); JavaScript.RequestRegistration(CommonJs.jQueryUI); JavaScript.RequestRegistration(CommonJs.DnnPlugins); }

Delete Spam Registrations

Sat, 14 Jun 2014 12:56:00 GMT

UPDATE UserPortals SET IsDeleted = 1 WHERE (UserId > 5)

DNN Check for Authentication and Redirect to Login Page

Thu, 17 Apr 2014 10:44:00 GMT

Note that you must define a login page in the Admin/Site Settings module. if (!IsPostBack) { if (UserId == -1) { Response.Redirect(Globals.NavigateURL(this.PortalSettings.LoginTabId)); } GetNewSearchURL(); LoadGrid(); lblDailyEmails.Text = Localization.GetString("lblDailyEmails", this.LocalResourceFile); SetLinks(); }

Send a password reminder email from a custom module

Mon, 16 Dec 2013 13:18:00 GMT

UserInfo u = new UserInfo(); u = UserController.GetUserById(PortalId, DnnUserId); u.Membership.Password = UserController.GetPassword(ref u, ""); DotNetNuke.Services.Mail.Mail.SendMail(u, DotNetNuke.Services.Mail.MessageType.PasswordReminder, PortalSettings);

Deleting All DNN Users from a Custom DNN Module

Sun, 08 Sep 2013 14:25:00 GMT

using DotNetNuke.Entities.Users; protected void Button1_Click(object sender, EventArgs e) { UserController.DeleteUsers(this.PortalId, false, false); }

Activating Advanced Url Management

Sat, 07 Sep 2013 13:39:00 GMT

To switch from 'humanfriendly' mode to 'advanced' mode, follow these steps: Take a backup of the web.config file for your site Open the web.config file, and search for 'urlformat'. You should find this in the section, like this: Change the urlFormat value to 'advanced', like this: Save the web.config file. Request the home page of the new site - the site is now using the Advanced Url Format. Fully test the site to ensure it is operating as expected. If any issues are found, restore the web.config backup.

iDataReader loop to bind custom values to a CheckBoxList

Sun, 17 Feb 2013 15:20:00 GMT

Bind values from a custom table to a CheckBoxList bound from a DNN list public void UpdateTrueFalseQuestions() { try { FBClientsController controller = new FBClientsController(); FBClientsInfo item = new FBClientsInfo(); for (int i = 0; i < cblClientTrueFalseQuestions.Items.Count; i++) { item.TfQuestion = cblClientTrueFalseQuestions.Items[i].Value.ToString(); item.TfAnswer = cblClientTrueFalseQuestions.Items[i].Selected; item.ClientID = Int32.Parse(hidClientID.Value.ToString()); item.CreatedByUserID = this.UserId; controller.FBClientsTrueFalseQuestions_InsertUpdate(item); } lblMessage.Text = Localization.GetString("ClientUpdateSuccessful", this.LocalResourceFile); lblMessage.Visible = true; } catch (Exception ex) { Exceptions.ProcessModuleLoadException(this, ex); } }

Return SCOPE IDENTITY from a stored procedure to your custom DNN module

Mon, 21 Jan 2013 13:06:00 GMT

Your SQL stored procedure: INSERT INTO Invoices (InvoiceNumber, InvoiceDate, SupplierID, ModuleID, CreatedOnDate, CreatedByUserID, PortalID) VALUES (@InvoiceNumber, @InvoiceDate, @SupplierID, @ModuleId, GETDATE(), @CreatedByUserID, @PortalID) SELECT SCOPE_IDENTITY() Next, all the methods in your abstract data provider class and concrete data provider class should be written as functions that return an integer which is the SCOPE IDENTITY that the stored procedure returns. //SQLDataProvider public override int FBInvoice_Insert(string invoiceNumber, DateTime invoiceDate, int supplierID, int createdByUserID, int moduleId, int portalId) { return Convert.ToInt32(SqlHelper.ExecuteScalar(connectionString, GetFullyQualifiedName("FBInvoice_Insert"), invoiceNumber, invoiceDate, supplierID, createdByUserID, moduleId, portalId)); } // DataProvider.cs public abstract int FBInvoice_Insert(string invoiceNumber, DateTime invoiceDate, int supplierID, int createdByUserID, int moduleId, int portalId); // Controller.cs public int FBInvoice_Insert(FBFoodInventoryInfo info) { if (info.InvoiceNumber != string.Empty) { return Convert.ToInt32(DataProvider.Instance().FBInvoice_Insert(info.InvoiceNumber, info.InvoiceDate, info.SupplierID, info.CreatedByUserID, info.ModuleId, info.PortalId)); } else { return 0; } } // Get the ID of the newly inserted record int MyNewID = Null.NullInteger; MyNewID = controller.FBInvoice_Insert(item);

SEARCH Skin Object Attributes

Sat, 07 Jul 2012 11:09:00 GMT

The Search Skin Object has 3 important attributes: Attribute Values Default Description ShowSite True, False True display/hide option "Site" to perform a search of the current site (DNN portal) ShowWeb True, False True display/hide option "Web" to perform a search of the WWW using the search site, as set up in Site Settings (Google, Yahoo, MSN) UseWebForSite True, False False use the WWW search Site, as set up in Site Settings, to perform searches of the current site (DNN portal). Note: this uses the search index stored at the the search site; any non-public content will not be included! If you want to use the Search Skin Object for site search only, set both options ShowSite and ShowWeb to false, otherwise a single option button Site will be displayed.

Adding a Header Tag to a Custom DNN Module

Wed, 14 Mar 2012 19:21:00 GMT

string htmlHeaderTags = null; LiteralControl htmlHeaderCtrl = new LiteralControl(); htmlHeaderTags = ""; htmlHeaderCtrl.Text = htmlHeaderTags.ToString(); Page.Header.Controls.Add(htmlHeaderCtrl);

DNN E-Mail Address Lookup

Thu, 19 Jan 2012 10:50:00 GMT

Check to verify if an e-mail address has been previously registered: public bool LookupEmail(string EmailAddress) { try { int intRecords = 0; ArrayList u = new ArrayList(); u = UserController.GetUsersByEmail(this.PortalId, EmailAddress, 0, 1, ref intRecords); if (u.Count > 0) { return true; } else { return false; } } catch (Exception ex) { Exceptions.ProcessModuleLoadException(this, ex); return false; } }